[dbo].[BAEImisProductKitLoad]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisProductKitLoad

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@ProductKitCode	varchar(31)	31

SQL Script

create procedure [dbo].[BAEImisProductKitLoad] @ProductKitCode as
varchar(31)
AS
    SELECT *
    FROM Product_Kit AS pk JOIN OrderProduct AS op ON pk.ITEM_PRODUCT_CODE COLLATE database_default = op.ProductCode COLLATE database_default
    WHERE pk.ITEM_PRODUCT_CODE = @ProductKitCode;

GO

Uses

[dbo].[OrderProduct]
[dbo].[Product_Kit]
dbo